PROMPT *-*-*-*-*-*-  stc_cls_tb table creation STARTS... *-*-*-*-*-*-

DROP TABLE stc_cls_tb
/

CREATE TABLE stc_cls_tb
( stc_id      NUMBER
, stc_items   VARCHAR2(15)
, src_loc     VARCHAR2(5)
, trg_loc     VARCHAR2(5)
, stc_qty     NUMBER
, stc_typ     CHAR
, stc_desc    VARCHAR2(30)
)
/

PROMPT *-*-*-*-*-*-  stc_cls_tb table creation ENDS... *-*-*-*-*-*-

PROMPT *-*-*-*-*-*-  stc_cls_tb Data Insertion STARTS... *-*-*-*-*-*-

INSERT INTO stc_cls_tb( stc_id, stc_items, src_loc, trg_loc, stc_qty, stc_typ, stc_desc )
                VALUES( 1000  , 'Ink'    , 'SG'   ,'JPN'   , 19232  , 'L'    ,'Some_desc_01');
			
INSERT INTO stc_cls_tb( stc_id, stc_items, src_loc, trg_loc, stc_qty, stc_typ, stc_desc )
                VALUES( 1001  , 'Mat'    , 'IND'   ,'SG'   , 10222  , 'S'    ,'Some_desc_01');
				
INSERT INTO stc_cls_tb( stc_id, stc_items, src_loc, trg_loc, stc_qty, stc_typ, stc_desc )
                VALUES( 1002  , 'Itm_03' , 'JPN'   ,'HK'   , 989    , 'S'    ,'Some_desc_01');
				
COMMIT;
/

GRANT SELECT, INSERT, UPDATE ON stc_cls_tb TO HR;

PROMPT *-*-*-*-*-*-  stc_cls_tb Data Insertion ENDS... *-*-*-*-*-*-